SELECT cw_id idct,cw_nmb FROM categoriasw INNER JOIN concepto_categoria ON cw_id = cc_categoria
WHERE cw_estatus = "A" AND cc_concepto = "20"
AND cw_categoria IN (SELECT DISTINCT(a_categoria) FROM articulos
INNER JOIN articulosw ON a_id = aw_id WHERE a_estatus = "A" AND aw_tienda IN ("1","0"))